Formulas and functions basics
Formula: Any expression in a cell that starts with an equal sign (=). Formulas can contain functions, values, cell names, and operators.
Function: A predefined formula in MyOffice Spreadsheet that needs arguments to calculate correctly. For a complete list of functions, see Appendix A.
Formulas and functions basics
•Formulas always begin with an equal sign (=).
•The equal sign can be followed by functions, constants, cell references, operators, and other elements.
•All opening and closing parenthesis must be in sync.
•The mandatory arguments of functions must be specified.
•The constants should not contain a dollar sign ($).
|
In Windows, if "." is selected in the Customize format window, in Decimal symbol field, use "," instead of ";" as the separator of values in functions in the MyOffice Spreadsheet application. |
For the Cell and Info functions, enter text parameters in English, enclosing them in double quotes. For example, =CELL("contents";A2), =INFO("system").
